package com.yonyou.gmmc.service.dealer.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.yonyou.gmmc.common.annotation.OracleDb;
import com.yonyou.gmmc.service.dealer.model.TmUsers;

import tk.mybatis.mapper.common.Mapper;

@OracleDb
public interface TmUsersMapper extends Mapper<TmUsers> {
    
    public String selectUserIdByPhone(@Param("phone") String phone);
    
    public List<TmUsers> counselor(@Param("dealerCode") String dealerCode);

    public List<TmUsers> engineer(@Param("licenseNo") String licenseNo);
    
    public String selectPosition(@Param("userId") String userId);
    
    public Integer selectUserInfo(@Param("userId") String userId,@Param("phone") String phone);
    
    public String selectRelation(@Param("wxUserId") String wxUserId,@Param("phone") String phone);

    public List<TmUsers> counselors();
    
    public List<TmUsers> engineers();

	public List<TmUsers> queryTmUsersList(String phone);
}